DWM.xls - New version
Original Post
Hi,
I posted a new version of DWM.xls
There are many changes:
- Configuration worksheet: Check the different options (time/date formats, colors, amount of days)
- New column "Entered" (different from "Created", as it's updated on every reentry). It comes to fix a bug reported by Mark (Tasks will be sorted by this column instead of “Created”)
- Import tasks from old file: No need to copy/paste from your old file anymore. It will only work with files formatted for the old version (without additions, etc).
- Closing Date removed (it duplicated "End Time")
There's quite a bit of programming. I hope there aren't too many bugs.
Let me know what you think.
DWM.xls
http://rapidshare.com/files/381174218/DWM.xls
DWM for Excel.pdf
http://rapidshare.com/files/381174277/DWM_for_Excel.pdf
Walter
I posted a new version of DWM.xls
There are many changes:
- Configuration worksheet: Check the different options (time/date formats, colors, amount of days)
- New column "Entered" (different from "Created", as it's updated on every reentry). It comes to fix a bug reported by Mark (Tasks will be sorted by this column instead of “Created”)
- Import tasks from old file: No need to copy/paste from your old file anymore. It will only work with files formatted for the old version (without additions, etc).
- Closing Date removed (it duplicated "End Time")
There's quite a bit of programming. I hope there aren't too many bugs.
Let me know what you think.
DWM.xls
http://rapidshare.com/files/381174218/DWM.xls
DWM for Excel.pdf
http://rapidshare.com/files/381174277/DWM_for_Excel.pdf
Walter
Reply by moises
No warranty?
Just kidding.
I look forward to trying this. You've done a yeoman's job creating this. Thanks.
Just kidding.
I look forward to trying this. You've done a yeoman's job creating this. Thanks.
Reply by moises
Works nicely on my Windows machine. But it won't work correctly on my Vista machine.
On the latter, immediately after I download it, if I hit "Apply Changes" on the Configuration Tab, I get "A Problem Occurred When Trying to Set Colors." And it's prone to crashing.
On the latter, immediately after I download it, if I hit "Apply Changes" on the Configuration Tab, I get "A Problem Occurred When Trying to Set Colors." And it's prone to crashing.
Reply by Walter
Hi moises,
I forgot to warn about that. I don't know about Vista, but I had the same problem with Excel 2007. Apparently there's some incompatibility (since I'm using Excel's old method to set colors) and I couldn't find a workaround yet.
By now, this has to be done manually through Excel preferences. I can tell you how this is done if you want.
I forgot to warn about that. I don't know about Vista, but I had the same problem with Excel 2007. Apparently there's some incompatibility (since I'm using Excel's old method to set colors) and I couldn't find a workaround yet.
By now, this has to be done manually through Excel preferences. I can tell you how this is done if you want.
Reply by moises
Hi Walter,
That's great. Please let me know how to modify Excel 2007 on my Vista machine. The configurability of the dates is something that will be most useful on my Vista (home) machine. Thanks.
That's great. Please let me know how to modify Excel 2007 on my Vista machine. The configurability of the dates is something that will be most useful on my Vista (home) machine. Thanks.
Reply by Walter
Hi moses,
Excluding the colors, the other configuration options should work without problems. They don't?
Excluding the colors, the other configuration options should work without problems. They don't?
Reply by moises
I never was able to start work in Excel 2007. It's not that I changed the configuration for the colors. I would get the error without changing anything.
Reply by Walter
Meaning that you open the file, and immediately you're shown with an error message?
And if so, Excel crashes afterwards?
And if so, Excel crashes afterwards?
Reply by moises
It would return an error message as soon as I hit "Apply Changes" even if I made no changes and had entered no data in any tab.
Reply by Walter
If "A Problem Occurred When Trying to Set Colors" is shown, the rest of the configuration options (date formats, entry days) are still applied, only the colors are skipped.
Can you check if that's your case? (Assuming that you can continue working after the message its shown. I didn't understand if there's a crash or not).
You should enter a task and see if the date formats are the ones you specified, and so on.
Can you check if that's your case? (Assuming that you can continue working after the message its shown. I didn't understand if there's a crash or not).
You should enter a task and see if the date formats are the ones you specified, and so on.
Reply by moises
OK. I will try it again when I get home tonight.
Reply by Ilse
For me the file works perfect in Excel 2007. Thank you Walter. I has been great experience using your DWM file.
Reply by moises
Walter,
I downloaded it a few more times and crashed it a few more times.
I take a brand-new file. I add a few tasks to make sure it's working. Then I change the date formats and the month setting 28 days, and the week to 10 days. I ignore the error message about the colors. I add a few more tasks and it crashes.
Your older version is working fine for me in Excel 2007, so I will stick with that.
Thanks.
I downloaded it a few more times and crashed it a few more times.
I take a brand-new file. I add a few tasks to make sure it's working. Then I change the date formats and the month setting 28 days, and the week to 10 days. I ignore the error message about the colors. I add a few more tasks and it crashes.
Your older version is working fine for me in Excel 2007, so I will stick with that.
Thanks.
Reply by Walter
Moises,
I'll tell you what... i'll try to detect if the current version is 2007, and if so, skip the color setting.
Maybe this is what's causing the crashing.
Ilse,
I'm glad you find it useful :-)
I'll tell you what... i'll try to detect if the current version is 2007, and if so, skip the color setting.
Maybe this is what's causing the crashing.
Ilse,
I'm glad you find it useful :-)
Reply by Walter
Moises,
I've been playing with the options and I've found out that if you save the file as the 2007 format .xlsm, it does work, even with the colors.
With the current version, there's some hard-coding that makes the program to expect exactly "DWM.xls" (as I think you know). I'm preparing a version that can deal with any file name.
But it would be good if you could try with the newer format, and see how it works.
Thanks,
Walter
I've been playing with the options and I've found out that if you save the file as the 2007 format .xlsm, it does work, even with the colors.
With the current version, there's some hard-coding that makes the program to expect exactly "DWM.xls" (as I think you know). I'm preparing a version that can deal with any file name.
But it would be good if you could try with the newer format, and see how it works.
Thanks,
Walter
Reply by moises
Walter,
That seems to have done the trick. Thanks!
Before this, I was always prompted to save as an Excel 97-2003 Workbook. Now I saved it as an Excel Macro-enabled Workbook.
It looks like you solved another problem for me. I look forward to using it.
Your dedication to this is much appreciated.
moises
That seems to have done the trick. Thanks!
Before this, I was always prompted to save as an Excel 97-2003 Workbook. Now I saved it as an Excel Macro-enabled Workbook.
It looks like you solved another problem for me. I look forward to using it.
Your dedication to this is much appreciated.
moises
Reply by KP
Hi Walter,
Your macros are great, they stopped me giving up on DWM. However I have one question, on my pc (XP with Excel 2007) it takes about 20 seconds for the macros to run. I'm using an .xlsm file format. Any suggestions on why it runs so slowly?
Thanks in advance!!
Kirstie
(It's not all bad though as it does give me an opportunity to practice my deep breathing)
Your macros are great, they stopped me giving up on DWM. However I have one question, on my pc (XP with Excel 2007) it takes about 20 seconds for the macros to run. I'm using an .xlsm file format. Any suggestions on why it runs so slowly?
Thanks in advance!!
Kirstie
(It's not all bad though as it does give me an opportunity to practice my deep breathing)
Reply by Walter
Hi, Kirstie
Everytime you execute a macro you have to wait 20 seconds, or just when you open the file?
I really don't know why would that be, I'm sure it's not something related to the program itself.
I don't know of any, but maybe there are antivirus programs that check office macros before they get executed?
Anybody else having the same issue?
Everytime you execute a macro you have to wait 20 seconds, or just when you open the file?
I really don't know why would that be, I'm sure it's not something related to the program itself.
I don't know of any, but maybe there are antivirus programs that check office macros before they get executed?
Anybody else having the same issue?
Reply by moises
No problems with XP Professional with Excel 2003.
No problems with Vista and Excel 2007.
No problems with Vista and Excel 2007.
Reply by KP
Hi Walter
The waiting is everytime I execute a macro, though I've been timing all my actions since I posted and 20 seconds was the most extreme, between 6 and 10 is the average (which isn't really a problem, I've just got used to life happening 'instantly').
Thanks for responding so promptly!!
Kirstie
The waiting is everytime I execute a macro, though I've been timing all my actions since I posted and 20 seconds was the most extreme, between 6 and 10 is the average (which isn't really a problem, I've just got used to life happening 'instantly').
Thanks for responding so promptly!!
Kirstie
Reply by Walter
You are welcome, I'm sorry I couldn't help.
I'm going to post a new version soon, with a copy option (useful for recurrent tasks).
I'm going to post a new version soon, with a copy option (useful for recurrent tasks).